-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.0.16-nt


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema frool
--

CREATE DATABASE IF NOT EXISTS frool;
USE frool;

--
-- Definition of table `cities`
--

DROP TABLE IF EXISTS `cities`;
CREATE TABLE `cities` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(45) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cities`
--

/*!40000 ALTER TABLE `cities` DISABLE KEYS */;
INSERT INTO `cities` (`id`,`name`) VALUES 
 (1,'Cebu');
/*!40000 ALTER TABLE `cities` ENABLE KEYS */;


--
-- Definition of table `employers`
--

DROP TABLE IF EXISTS `employers`;
CREATE TABLE `employers` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `employer_name` varchar(45) default NULL,
  `abn` varchar(45) default NULL,
  `contact_name` varchar(45) default NULL,
  `phone` varchar(45) default NULL,
  `fax` varchar(45) default NULL,
  `address1` varchar(45) default NULL,
  `address2` varchar(45) default NULL,
  `address3` varchar(45) default NULL,
  `town` varchar(45) default NULL,
  `postcode` varchar(45) default NULL,
  `email` varchar(45) default NULL,
  `password` varchar(45) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employers`
--

/*!40000 ALTER TABLE `employers` DISABLE KEYS */;
INSERT INTO `employers` (`id`,`employer_name`,`abn`,`contact_name`,`phone`,`fax`,`address1`,`address2`,`address3`,`town`,`postcode`,`email`,`password`) VALUES 
 (1,'Bogetz Global Solutions Corp.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `employers` ENABLE KEYS */;


--
-- Definition of table `jobs`
--

DROP TABLE IF EXISTS `jobs`;
CREATE TABLE `jobs` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(45) default NULL,
  `description` varchar(2000) default NULL,
  `location` varchar(45) default NULL,
  `salary` varchar(45) default NULL,
  `work_type` varchar(45) default NULL,
  `tenancy` varchar(45) default NULL,
  `hours` varchar(45) default NULL,
  `no_of_positions` varchar(45) default NULL,
  `preferred_licenses` varchar(45) default NULL,
  `source` varchar(45) default NULL,
  `job_id` varchar(45) default NULL,
  `last_modified` datetime default NULL,
  `options` varchar(45) default NULL,
  `how_to_apply` varchar(2000) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jobs`
--

/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
INSERT INTO `jobs` (`id`,`name`,`description`,`location`,`salary`,`work_type`,`tenancy`,`hours`,`no_of_positions`,`preferred_licenses`,`source`,`job_id`,`last_modified`,`options`,`how_to_apply`) VALUES 
 (1,'Weed Sprayer','We are looking for a Qualified weed sprayer. Must have OH&S card, chem cert. duties include: weed spraying physical hard labour. Must be reliable, enthusiastic and willing to work. D/L and own transport is essential.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2009-11-27 18:03:58',NULL,'To apply, please phone IPM Officer at Campbell Page Braidwood Employment Hub;Braidwood by phoning 1300139920.\n\nJob seekers with a Job Services Australia Card are encouraged to apply.'),
 (2,'Assistant Screen Printer','2x screen printing assistants positions available for local screen printing company located in Queanbeyan. EXP NOT ESSENTIAL, have interest in printing and screen printing, must have attention to detail and great organizational skills. Duties will be, assisting printing of shirts etc, processing orders, checking shirts and orders. Public transport available and hours are 8.30am-4.30pm. Please send all applications including your resume, cover letter and job seeker ID (if applicable) and availability to queanbeyanjobs@auswideprojects.com.au or call 62005930 for more information. If you do not receive a reply within 3 days please consider yourself unsuccessful on this occasion.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'To apply, please phone at Auswide - Caloola Enterprises QUEANBEYAN by phoning 02 62005930.\n\nEnquiries from all suitable job seekers welcome.'),
 (3,'Home Support Worker','This is a new organisation opening soon in the Queanbeyan area. You will be required to assist with the day to day care of the elderly and the disabled member of our community. Duties include providing personal care, domestic assistance, transport to Doctor\'s appointment, shopping and rest for carers. This is a great opportunity and training will be provided. If you are honest and reliable and have a desire to work in the community services industry please send your resume and covering letter to queanbeyanjobs@auswideprojects.com.au or contact our office for further information on (02) 62005930',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'To apply, please phone at Auswide - Caloola Enterprises QUEANBEYAN by phoning 02 62005930.\n\nEnquiries from all suitable job seekers welcome.');
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;


--
-- Definition of table `occupations`
--

DROP TABLE IF EXISTS `occupations`;
CREATE TABLE `occupations` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(45) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `occupations`
--

/*!40000 ALTER TABLE `occupations` DISABLE KEYS */;
INSERT INTO `occupations` (`id`,`name`) VALUES 
 (1,'Green Corps'),
 (2,'Australian Apprenticeships'),
 (3,'New jobs');
/*!40000 ALTER TABLE `occupations` ENABLE KEYS */;


--
-- Definition of table `states`
--

DROP TABLE IF EXISTS `states`;
CREATE TABLE `states` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(45) default NULL,
  PRIMARY KEY  USING BTREE (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `states`
--

/*!40000 ALTER TABLE `states` DISABLE KEYS */;
INSERT INTO `states` (`id`,`name`) VALUES 
 (1,'Cebu'),
 (2,'Manila'),
 (3,'Davao');
/*!40000 ALTER TABLE `states` ENABLE KEYS */;


--
-- Definition of table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(45) default NULL,
  `password` varchar(45) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

/*!40000 ALTER TABLE `users` DISABLE KEYS */;
/*!40000 ALTER TABLE `users` ENABLE KEYS */;




/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
